package com.ctgu.fcftsystem.dao;

import com.ctgu.fcftsystem.pojo.Securities;
import com.ctgu.fcftsystem.pojo.Sercurity_trade;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
@Mapper
public interface SecuritiesDao {

    List<Securities> findByPaging(int pageCount, int pageSize);

    /**
     * 添加证券用户
     * @param securities
     * @return
     */
    int addSecurities(@Param("securities") Securities securities);

    /**
     * 根据持有人、证券公司、证券类型、起始时间和截止时间进行多重条件查询
     * @param securitiesOwner
     * @param securitiesCompany
     * @param securitierType
     * @param starTime
     * @param endTime
     * @return
     */
    List<Securities> searchSecuritiesUser(@Param("securitiesOwner") String securitiesOwner
            , @Param("securitiesCompany") String securitiesCompany
            , @Param("securitierType") String securitierType
            , @Param("starTime") String starTime, @Param("endTime") String endTime);


    //通过id删除证券用户信息
    int deleteSecuritiesUsrById(@Param("id") int id);

    //维护证券用户信息
    int updateSecuritiesUsrById(@Param("securities") Securities securities);

}
